
export const columnMap = [

  {sourceCol: 'iyear', updateCol: 'year'},
  {sourceCol: '会计年', updateCol: 'year'},
  {sourceCol: '年份　', updateCol: 'year'},
  
  {sourceCol: 'isignseq', updateCol: 'voucherType'},
  {sourceCol: '凭证类型编号', updateCol: 'voucherType'},
  {sourceCol: '凭证类别排序', updateCol: 'voucherType'},

  {sourceCol: 'iperiod', updateCol: 'month'},
  {sourceCol: '会计期间', updateCol: 'month'},
  {sourceCol: '会计月', updateCol: 'month'},
  {sourceCol: '月份　', updateCol: 'month'},  

  {sourceCol: 'dbill_date', updateCol: 'billDate'},
  {sourceCol: '记账时间', updateCol: 'billDate', handle: 'EXCEL_DATE'},

  {sourceCol: 'code', updateCol: 'code'},
  {sourceCol: 'ccode', updateCol: 'code'},
  {sourceCol: '科目编号', updateCol: 'code'},
  {sourceCol: '科目编码', updateCol: 'code'},

  {sourceCol: 'name', updateCol: 'name'},
  {sourceCol: 'ccode_name', updateCol: 'name'},
  {sourceCol: '科目名称', updateCol: 'name'},

  {sourceCol: 'cclass', updateCol: 'categoryType'},
  {sourceCol: '科目类别', updateCol: 'categoryType'},

  {sourceCol: `期初　　　　`, updateCol: 'opening', handle: 'NUMBER'},
  {sourceCol: `期初数　　　`, updateCol: 'opening', handle: 'NUMBER'},
  {sourceCol: `期初余额　　`, updateCol: 'opening', handle: 'NUMBER'},
  {sourceCol: `账面期初数　`, updateCol: 'opening', handle: 'NUMBER'},
  {sourceCol: `账面期初余额`, updateCol: 'opening', handle: 'NUMBER'},
  {sourceCol: `期初金额　　`, updateCol: 'opening', handle: 'NUMBER'},
  {sourceCol: `期初方向　　`, updateCol: `openingDir`, handle: 'DIRECTION'},
  {sourceCol: `期初余额借方`, updateCol: `openingDr`, handle: 'NUMBER'},
  {sourceCol: `期初余额贷方`, updateCol: `openingCr`, handle: 'NUMBER'},

  {sourceCol: `期末　　　　`, updateCol: 'closing', handle: 'NUMBER'},
  {sourceCol: `期末数　　　`, updateCol: 'closing', handle: 'NUMBER'},
  {sourceCol: `期末余额　　`, updateCol: 'closing', handle: 'NUMBER'},
  {sourceCol: `账面期末数　`, updateCol: 'closing', handle: 'NUMBER'},
  {sourceCol: `账面期末余额`, updateCol: 'closing', handle: 'NUMBER'},
  {sourceCol: `期末金额　　`, updateCol: 'closing', handle: 'NUMBER'},
  {sourceCol: `期末方向　　`, updateCol: `closingDir`, handle: 'DIRECTION'},
  {sourceCol: `期末余额借方`, updateCol: `closingDr`, handle: 'NUMBER'},
  {sourceCol: `期末余额贷方`, updateCol: `closingCr`, handle: 'NUMBER'},

  {sourceCol: 'md', updateCol: 'dr', handle: 'NUMBER'},
  {sourceCol: `借方　　　　　`, updateCol: 'dr', handle: 'NUMBER'},
  {sourceCol: `本期借方　　　`, updateCol: 'dr', handle: 'NUMBER'},
  {sourceCol: `借方发生　　　`, updateCol: 'dr', handle: 'NUMBER'},
  {sourceCol: `借方发生额　　`, updateCol: 'dr', handle: 'NUMBER'},
  {sourceCol: `本期发生借方　`, updateCol: 'dr', handle: 'NUMBER'},
  {sourceCol: `未审借方发生额`, updateCol: 'dr', handle: 'NUMBER'},
  {sourceCol: `账面借方发生额`, updateCol: 'dr', handle: 'NUMBER'},

  {sourceCol: 'mc', updateCol: 'cr'},
  {sourceCol: `借方　　　　　`, updateCol: 'cr', handle: 'NUMBER'},
  {sourceCol: `本期借方　　　`, updateCol: 'cr', handle: 'NUMBER'},
  {sourceCol: `借方发生　　　`, updateCol: 'cr', handle: 'NUMBER'},
  {sourceCol: `借方发生额　　`, updateCol: 'cr', handle: 'NUMBER'},
  {sourceCol: `本期发生借方　`, updateCol: 'cr', handle: 'NUMBER'},
  {sourceCol: `未审借方发生额`, updateCol: 'cr', handle: 'NUMBER'},
  {sourceCol: `账面借方发生额`, updateCol: 'cr', handle: 'NUMBER'},

  {sourceCol: 'ino_id', updateCol: 'voucherID'},
  {sourceCol: '凭证编号', updateCol: 'voucherID'},
  {sourceCol: '凭证号　', updateCol: 'voucherID'},

  {sourceCol: 'inid', updateCol: 'lineID'},
  {sourceCol: '编号　', updateCol: 'lineID'},
  {sourceCol: '行号　', updateCol: 'lineID'},
  {sourceCol: '凭证行', updateCol: 'lineID'},
  {sourceCol: '凭证行号', updateCol: 'lineID'},

  {sourceCol: 'cdigest', updateCol: 'desc'},
  {sourceCol: '摘要　　　', updateCol: 'desc'},
  {sourceCol: '业务说明　', updateCol: 'desc'},

  {sourceCol: '核算项目', updateCol: 'itemName'},
  {sourceCol: '核算项目名称', updateCol: 'itemName'},
  
  {sourceCol: '核算项目ID', updateCol: 'itemCode'},
  {sourceCol: '核算项目编号', updateCol: 'itemCode'},

  {sourceCol: '核算项目类型名称', updateCol: 'itemTypeName'},
  {sourceCol: '核算项目类型编号', updateCol: 'itemTypeCode'},

  {sourceCol: '条目编号', updateCol: 'code'},
  {sourceCol: '条目名称', updateCol: 'name'},
]